Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 457100 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 152.2 MiB |
| Average record size in memory | 349.2 B |
Variable types
| Text | 2 |
|---|---|
| DateTime | 2 |
| Numeric | 8 |
JamsCount is highly overall correlated with JamsDelay and 6 other fields | High correlation |
JamsDelay is highly overall correlated with JamsCount and 6 other fields | High correlation |
JamsLengthInKms is highly overall correlated with JamsCount and 5 other fields | High correlation |
MinsDelay is highly overall correlated with JamsCount and 6 other fields | High correlation |
TrafficIndexLive is highly overall correlated with JamsCount and 6 other fields | High correlation |
TrafficIndexWeekAgo is highly overall correlated with JamsCount and 6 other fields | High correlation |
TravelTimeHistoricPer10KmsMins is highly overall correlated with JamsCount and 5 other fields | High correlation |
TravelTimeLivePer10KmsMins is highly overall correlated with JamsCount and 6 other fields | High correlation |
TravelTimeLivePer10KmsMins has unique values | Unique |
TravelTimeHistoricPer10KmsMins has unique values | Unique |
MinsDelay has unique values | Unique |
JamsDelay has 107393 (23.5%) zeros | Zeros |
TrafficIndexLive has 92030 (20.1%) zeros | Zeros |
JamsLengthInKms has 109386 (23.9%) zeros | Zeros |
JamsCount has 107393 (23.5%) zeros | Zeros |
TrafficIndexWeekAgo has 89950 (19.7%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-17 13:17:08.076542 |
|---|---|
| Analysis finished | 2024-11-17 13:17:16.435120 |
| Duration | 8.36 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
Country
Text
| Distinct | 55 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.2 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1371300 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ARE |
|---|---|
| 2nd row | ARE |
| 3rd row | ARE |
| 4th row | ARE |
| 5th row | ARE |
| Value | Count | Frequency (%) |
| usa | 93913 | |
| deu | 31920 | 7.0% |
| gbr | 29819 | 6.5% |
| fra | 29622 | 6.5% |
| ita | 29495 | 6.5% |
| esp | 29493 | 6.5% |
| nld | 20047 | 4.4% |
| pol | 14168 | 3.1% |
| can | 14129 | 3.1% |
| tur | 11916 | 2.6% |
| Other values (45) | 152578 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 219111 | |
| U | 167258 | |
| S | 154064 | |
| R | 111540 | 8.1% |
| E | 100402 | 7.3% |
| N | 73236 | 5.3% |
| T | 65166 | 4.8% |
| L | 65046 | 4.7% |
| D | 61417 | 4.5% |
| P | 59182 | 4.3% |
| Other values (16) | 294878 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1371300 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 219111 | |
| U | 167258 | |
| S | 154064 | |
| R | 111540 | 8.1% |
| E | 100402 | 7.3% |
| N | 73236 | 5.3% |
| T | 65166 | 4.8% |
| L | 65046 | 4.7% |
| D | 61417 | 4.5% |
| P | 59182 | 4.3% |
| Other values (16) | 294878 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1371300 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 219111 | |
| U | 167258 | |
| S | 154064 | |
| R | 111540 | 8.1% |
| E | 100402 | 7.3% |
| N | 73236 | 5.3% |
| T | 65166 | 4.8% |
| L | 65046 | 4.7% |
| D | 61417 | 4.5% |
| P | 59182 | 4.3% |
| Other values (16) | 294878 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1371300 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 219111 | |
| U | 167258 | |
| S | 154064 | |
| R | 111540 | 8.1% |
| E | 100402 | 7.3% |
| N | 73236 | 5.3% |
| T | 65166 | 4.8% |
| L | 65046 | 4.7% |
| D | 61417 | 4.5% |
| P | 59182 | 4.3% |
| Other values (16) | 294878 |
City
Text
| Distinct | 384 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 MiB |
Length
| Max length | 28 |
|---|---|
| Median length | 20 |
| Mean length | 8.2014439 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3748880 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | abu-dhabi |
|---|---|
| 2nd row | abu-dhabi |
| 3rd row | abu-dhabi |
| 4th row | abu-dhabi |
| 5th row | abu-dhabi |
| Value | Count | Frequency (%) |
| birmingham | 2377 | 0.5% |
| london | 2367 | 0.5% |
| hamilton | 2359 | 0.5% |
| manila | 1227 | 0.3% |
| kuwait-city | 1207 | 0.3% |
| kobe | 1205 | 0.3% |
| reading | 1204 | 0.3% |
| singapore | 1203 | 0.3% |
| edinburgh | 1203 | 0.3% |
| osaka | 1203 | 0.3% |
| Other values (374) | 441545 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 431125 | 11.5% |
| e | 338791 | 9.0% |
| n | 310657 | 8.3% |
| o | 287924 | 7.7% |
| r | 273957 | 7.3% |
| i | 245717 | 6.6% |
| l | 230116 | 6.1% |
| s | 198082 | 5.3% |
| t | 191174 | 5.1% |
| u | 131137 | 3.5% |
| Other values (17) | 1110200 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3748880 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 431125 | 11.5% |
| e | 338791 | 9.0% |
| n | 310657 | 8.3% |
| o | 287924 | 7.7% |
| r | 273957 | 7.3% |
| i | 245717 | 6.6% |
| l | 230116 | 6.1% |
| s | 198082 | 5.3% |
| t | 191174 | 5.1% |
| u | 131137 | 3.5% |
| Other values (17) | 1110200 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3748880 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 431125 | 11.5% |
| e | 338791 | 9.0% |
| n | 310657 | 8.3% |
| o | 287924 | 7.7% |
| r | 273957 | 7.3% |
| i | 245717 | 6.6% |
| l | 230116 | 6.1% |
| s | 198082 | 5.3% |
| t | 191174 | 5.1% |
| u | 131137 | 3.5% |
| Other values (17) | 1110200 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3748880 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 431125 | 11.5% |
| e | 338791 | 9.0% |
| n | 310657 | 8.3% |
| o | 287924 | 7.7% |
| r | 273957 | 7.3% |
| i | 245717 | 6.6% |
| l | 230116 | 6.1% |
| s | 198082 | 5.3% |
| t | 191174 | 5.1% |
| u | 131137 | 3.5% |
| Other values (17) | 1110200 |
UpdateTimeUTC
Date
| Distinct | 30408 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.5 MiB |
| Minimum | 2024-10-01 07:00:59.231000 |
|---|---|
| Maximum | 2024-11-17 11:31:30.001000 |
Histogram with fixed size bins (bins=50)
JamsDelay
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 24093 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 183.88355 |
| Minimum | 0 |
|---|---|
| Maximum | 15568.6 |
| Zeros | 107393 |
| Zeros (%) | 23.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.1 |
| median | 16.4 |
| Q3 | 101.9 |
| 95-th percentile | 879.3 |
| Maximum | 15568.6 |
| Range | 15568.6 |
| Interquartile range (IQR) | 100.8 |
Descriptive statistics
| Standard deviation | 585.42049 |
|---|---|
| Coefficient of variation (CV) | 3.1836479 |
| Kurtosis | 70.121023 |
| Mean | 183.88355 |
| Median Absolute Deviation (MAD) | 16.4 |
| Skewness | 7.0911169 |
| Sum | 84053172 |
| Variance | 342717.15 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 107393 | 23.5% |
| 2.6 | 2125 | 0.5% |
| 2.8 | 1946 | 0.4% |
| 2.7 | 1921 | 0.4% |
| 2.5 | 1803 | 0.4% |
| 3 | 1770 | 0.4% |
| 2.9 | 1758 | 0.4% |
| 3.1 | 1687 | 0.4% |
| 1.1 | 1655 | 0.4% |
| 3.3 | 1556 | 0.3% |
| Other values (24083) | 333486 |
| Value | Count | Frequency (%) |
| 0 | 107393 | |
| 0.3 | 1 | < 0.1% |
| 0.4 | 330 | 0.1% |
| 0.5 | 1078 | 0.2% |
| 0.6 | 1149 | 0.3% |
| 0.7 | 961 | 0.2% |
| 0.8 | 905 | 0.2% |
| 0.9 | 1054 | 0.2% |
| 1 | 1394 | 0.3% |
| 1.1 | 1655 | 0.4% |
| Value | Count | Frequency (%) |
| 15568.6 | 1 | |
| 15503.2 | 1 | |
| 15079.8 | 1 | |
| 13946.4 | 1 | |
| 13125.4 | 1 | |
| 13090.9 | 1 | |
| 12717 | 1 | |
| 12582.6 | 1 | |
| 12470.9 | 1 | |
| 12465.9 | 1 |
TrafficIndexLive
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 176 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.508068 |
| Minimum | 0 |
|---|---|
| Maximum | 221 |
| Zeros | 92030 |
| Zeros (%) | 20.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 14 |
| Q3 | 30 |
| 95-th percentile | 61 |
| Maximum | 221 |
| Range | 221 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 20.376544 |
|---|---|
| Coefficient of variation (CV) | 1.0445188 |
| Kurtosis | 2.2908557 |
| Mean | 19.508068 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 1.3880882 |
| Sum | 8917138 |
| Variance | 415.20355 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 92030 | 20.1% |
| 1 | 13498 | 3.0% |
| 2 | 12376 | 2.7% |
| 3 | 11241 | 2.5% |
| 4 | 10522 | 2.3% |
| 5 | 10130 | 2.2% |
| 6 | 9876 | 2.2% |
| 7 | 9622 | 2.1% |
| 8 | 9538 | 2.1% |
| 9 | 9487 | 2.1% |
| Other values (166) | 268780 |
| Value | Count | Frequency (%) |
| 0 | 92030 | |
| 1 | 13498 | 3.0% |
| 2 | 12376 | 2.7% |
| 3 | 11241 | 2.5% |
| 4 | 10522 | 2.3% |
| 5 | 10130 | 2.2% |
| 6 | 9876 | 2.2% |
| 7 | 9622 | 2.1% |
| 8 | 9538 | 2.1% |
| 9 | 9487 | 2.1% |
| Value | Count | Frequency (%) |
| 221 | 1 | < 0.1% |
| 219 | 1 | < 0.1% |
| 210 | 1 | < 0.1% |
| 194 | 1 | < 0.1% |
| 193 | 1 | < 0.1% |
| 192 | 1 | < 0.1% |
| 181 | 2 | |
| 175 | 3 | |
| 173 | 1 | < 0.1% |
| 172 | 1 | < 0.1% |
JamsLengthInKms
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 8252 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.182389 |
| Minimum | 0 |
|---|---|
| Maximum | 1918 |
| Zeros | 109386 |
| Zeros (%) | 23.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.1 |
| median | 2.5 |
| Q3 | 18.4 |
| 95-th percentile | 170.4 |
| Maximum | 1918 |
| Range | 1918 |
| Interquartile range (IQR) | 18.3 |
Descriptive statistics
| Standard deviation | 100.32101 |
|---|---|
| Coefficient of variation (CV) | 3.023321 |
| Kurtosis | 50.532547 |
| Mean | 33.182389 |
| Median Absolute Deviation (MAD) | 2.5 |
| Skewness | 6.1959777 |
| Sum | 15167670 |
| Variance | 10064.306 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 109386 | 23.9% |
| 0.2 | 14534 | 3.2% |
| 0.1 | 10636 | 2.3% |
| 0.3 | 10227 | 2.2% |
| 0.4 | 8200 | 1.8% |
| 0.5 | 6914 | 1.5% |
| 0.6 | 5964 | 1.3% |
| 0.7 | 5386 | 1.2% |
| 0.8 | 4901 | 1.1% |
| 0.9 | 4560 | 1.0% |
| Other values (8242) | 276392 |
| Value | Count | Frequency (%) |
| 0 | 109386 | |
| 0.1 | 10636 | 2.3% |
| 0.2 | 14534 | 3.2% |
| 0.3 | 10227 | 2.2% |
| 0.4 | 8200 | 1.8% |
| 0.5 | 6914 | 1.5% |
| 0.6 | 5964 | 1.3% |
| 0.7 | 5386 | 1.2% |
| 0.8 | 4901 | 1.1% |
| 0.9 | 4560 | 1.0% |
| Value | Count | Frequency (%) |
| 1918 | 1 | |
| 1758.1 | 1 | |
| 1757.3 | 1 | |
| 1727.6 | 1 | |
| 1690.1 | 1 | |
| 1686.7 | 1 | |
| 1666.1 | 1 | |
| 1660.4 | 1 | |
| 1653.2 | 1 | |
| 1640 | 1 |
JamsCount
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 1760 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.666392 |
| Minimum | 0 |
|---|---|
| Maximum | 3102 |
| Zeros | 107393 |
| Zeros (%) | 23.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 5 |
| Q3 | 29 |
| 95-th percentile | 219 |
| Maximum | 3102 |
| Range | 3102 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 133.81254 |
|---|---|
| Coefficient of variation (CV) | 2.9302192 |
| Kurtosis | 55.471919 |
| Mean | 45.666392 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 6.405768 |
| Sum | 20874108 |
| Variance | 17905.795 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 107393 | |
| 1 | 47403 | 10.4% |
| 2 | 28279 | 6.2% |
| 3 | 19968 | 4.4% |
| 4 | 15533 | 3.4% |
| 5 | 12907 | 2.8% |
| 6 | 11020 | 2.4% |
| 7 | 9581 | 2.1% |
| 8 | 8413 | 1.8% |
| 9 | 7461 | 1.6% |
| Other values (1750) | 189142 |
| Value | Count | Frequency (%) |
| 0 | 107393 | |
| 1 | 47403 | |
| 2 | 28279 | 6.2% |
| 3 | 19968 | 4.4% |
| 4 | 15533 | 3.4% |
| 5 | 12907 | 2.8% |
| 6 | 11020 | 2.4% |
| 7 | 9581 | 2.1% |
| 8 | 8413 | 1.8% |
| 9 | 7461 | 1.6% |
| Value | Count | Frequency (%) |
| 3102 | 1 | |
| 3007 | 1 | |
| 2962 | 1 | |
| 2796 | 1 | |
| 2656 | 1 | |
| 2637 | 1 | |
| 2626 | 1 | |
| 2487 | 1 | |
| 2466 | 1 | |
| 2378 | 1 |
TrafficIndexWeekAgo
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 172 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.783448 |
| Minimum | 0 |
|---|---|
| Maximum | 221 |
| Zeros | 89950 |
| Zeros (%) | 19.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 14 |
| Q3 | 30 |
| 95-th percentile | 61 |
| Maximum | 221 |
| Range | 221 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 20.425471 |
|---|---|
| Coefficient of variation (CV) | 1.0324525 |
| Kurtosis | 2.1378074 |
| Mean | 19.783448 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 1.3555772 |
| Sum | 9043014 |
| Variance | 417.19986 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 89950 | 19.7% |
| 1 | 13243 | 2.9% |
| 2 | 12232 | 2.7% |
| 3 | 11119 | 2.4% |
| 4 | 10506 | 2.3% |
| 5 | 10005 | 2.2% |
| 6 | 9764 | 2.1% |
| 7 | 9480 | 2.1% |
| 9 | 9451 | 2.1% |
| 8 | 9358 | 2.0% |
| Other values (162) | 271992 |
| Value | Count | Frequency (%) |
| 0 | 89950 | |
| 1 | 13243 | 2.9% |
| 2 | 12232 | 2.7% |
| 3 | 11119 | 2.4% |
| 4 | 10506 | 2.3% |
| 5 | 10005 | 2.2% |
| 6 | 9764 | 2.1% |
| 7 | 9480 | 2.1% |
| 8 | 9358 | 2.0% |
| 9 | 9451 | 2.1% |
| Value | Count | Frequency (%) |
| 221 | 1 | |
| 219 | 1 | |
| 210 | 1 | |
| 193 | 1 | |
| 192 | 1 | |
| 181 | 2 | |
| 175 | 2 | |
| 173 | 1 | |
| 168 | 1 | |
| 167 | 1 |
| Distinct | 30009 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.5 MiB |
| Minimum | 2024-09-24 06:31:00 |
|---|---|
| Maximum | 2024-11-10 12:16:30 |
Histogram with fixed size bins (bins=50)
TravelTimeLivePer10KmsMins
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 457100 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.812645 |
| Minimum | 5.7764833 |
|---|---|
| Maximum | 46.887477 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 5.7764833 |
|---|---|
| 5-th percentile | 8.4160899 |
| Q1 | 10.95649 |
| median | 13.111839 |
| Q3 | 15.820933 |
| 95-th percentile | 21.548827 |
| Maximum | 46.887477 |
| Range | 41.110994 |
| Interquartile range (IQR) | 4.8644432 |
Descriptive statistics
| Standard deviation | 4.1637788 |
|---|---|
| Coefficient of variation (CV) | 0.30144689 |
| Kurtosis | 3.4290628 |
| Mean | 13.812645 |
| Median Absolute Deviation (MAD) | 2.3799481 |
| Skewness | 1.3587791 |
| Sum | 6313760 |
| Variance | 17.337054 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9.44007779 | 1 | < 0.1% |
| 14.38688337 | 1 | < 0.1% |
| 9.150249501 | 1 | < 0.1% |
| 8.411789678 | 1 | < 0.1% |
| 8.214035932 | 1 | < 0.1% |
| 7.917927296 | 1 | < 0.1% |
| 7.90137162 | 1 | < 0.1% |
| 7.956428884 | 1 | < 0.1% |
| 7.965113859 | 1 | < 0.1% |
| 9.233829145 | 1 | < 0.1% |
| Other values (457090) | 457090 |
| Value | Count | Frequency (%) |
| 5.776483271 | 1 | |
| 5.831333938 | 1 | |
| 5.831833009 | 1 | |
| 5.834200285 | 1 | |
| 5.839213766 | 1 | |
| 5.854329187 | 1 | |
| 5.85580656 | 1 | |
| 5.860116819 | 1 | |
| 5.868758867 | 1 | |
| 5.869186603 | 1 |
| Value | Count | Frequency (%) |
| 46.88747696 | 1 | |
| 46.26949178 | 1 | |
| 45.93734285 | 1 | |
| 45.92560347 | 1 | |
| 45.34972789 | 1 | |
| 45.3164593 | 1 | |
| 45.17186128 | 1 | |
| 45.04707754 | 1 | |
| 44.96962674 | 1 | |
| 44.85698921 | 1 |
TravelTimeHistoricPer10KmsMins
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 457100 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.118687 |
| Minimum | 5.8686899 |
|---|---|
| Maximum | 36.7602 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 5.8686899 |
|---|---|
| 5-th percentile | 8.4097922 |
| Q1 | 10.690081 |
| median | 12.591903 |
| Q3 | 14.886538 |
| 95-th percentile | 19.522039 |
| Maximum | 36.7602 |
| Range | 30.89151 |
| Interquartile range (IQR) | 4.196457 |
Descriptive statistics
| Standard deviation | 3.5526398 |
|---|---|
| Coefficient of variation (CV) | 0.27080757 |
| Kurtosis | 3.2826281 |
| Mean | 13.118687 |
| Median Absolute Deviation (MAD) | 2.065687 |
| Skewness | 1.3122071 |
| Sum | 5996551.9 |
| Variance | 12.62125 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9.550711374 | 1 | < 0.1% |
| 12.06822416 | 1 | < 0.1% |
| 9.215192301 | 1 | < 0.1% |
| 8.547720595 | 1 | < 0.1% |
| 8.311061937 | 1 | < 0.1% |
| 7.846066317 | 1 | < 0.1% |
| 7.686530387 | 1 | < 0.1% |
| 7.785518161 | 1 | < 0.1% |
| 7.737355344 | 1 | < 0.1% |
| 8.96071192 | 1 | < 0.1% |
| Other values (457090) | 457090 |
| Value | Count | Frequency (%) |
| 5.868689949 | 1 | |
| 5.87744231 | 1 | |
| 5.888246626 | 1 | |
| 5.904652205 | 1 | |
| 5.918415195 | 1 | |
| 5.932137416 | 1 | |
| 5.945464936 | 1 | |
| 5.955924955 | 1 | |
| 5.966648468 | 1 | |
| 5.981403825 | 1 |
| Value | Count | Frequency (%) |
| 36.76019957 | 1 | |
| 36.46664313 | 1 | |
| 36.25273362 | 1 | |
| 36.17668883 | 1 | |
| 35.7606891 | 1 | |
| 35.64287755 | 1 | |
| 35.62543869 | 1 | |
| 35.53547586 | 1 | |
| 35.52896702 | 1 | |
| 35.50102837 | 1 |
MinsDelay
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 457100 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.69395763 |
| Minimum | -11.695612 |
|---|---|
| Maximum | 20.499677 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 87657 |
| Negative (%) | 19.2% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | -11.695612 |
|---|---|
| 5-th percentile | -0.24230507 |
| Q1 | 0.066533428 |
| median | 0.37274832 |
| Q3 | 0.96306094 |
| 95-th percentile | 2.8161412 |
| Maximum | 20.499677 |
| Range | 32.195289 |
| Interquartile range (IQR) | 0.89652751 |
Descriptive statistics
| Standard deviation | 1.0978297 |
|---|---|
| Coefficient of variation (CV) | 1.5819838 |
| Kurtosis | 13.59648 |
| Mean | 0.69395763 |
| Median Absolute Deviation (MAD) | 0.37900224 |
| Skewness | 2.4874348 |
| Sum | 317208.03 |
| Variance | 1.2052301 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -0.1106335845 | 1 | < 0.1% |
| 2.31865921 | 1 | < 0.1% |
| -0.06494280014 | 1 | < 0.1% |
| -0.1359309165 | 1 | < 0.1% |
| -0.09702600539 | 1 | < 0.1% |
| 0.07186097887 | 1 | < 0.1% |
| 0.2148412331 | 1 | < 0.1% |
| 0.1709107236 | 1 | < 0.1% |
| 0.2277585148 | 1 | < 0.1% |
| 0.2731172255 | 1 | < 0.1% |
| Other values (457090) | 457090 |
| Value | Count | Frequency (%) |
| -11.69561206 | 1 | |
| -10.8555978 | 1 | |
| -10.70780758 | 1 | |
| -9.939216213 | 1 | |
| -9.712700717 | 1 | |
| -9.682370834 | 1 | |
| -9.432611487 | 1 | |
| -9.138384452 | 1 | |
| -9.110297858 | 1 | |
| -8.959010291 | 1 |
| Value | Count | Frequency (%) |
| 20.49967721 | 1 | |
| 20.37719588 | 1 | |
| 20.34223625 | 1 | |
| 20.1674452 | 1 | |
| 20.0642045 | 1 | |
| 19.30786826 | 1 | |
| 18.76104088 | 1 | |
| 17.15354808 | 1 | |
| 17.12523348 | 1 | |
| 16.07952071 | 1 |
| JamsCount | JamsDelay | JamsLengthInKms | MinsDelay | TrafficIndexLive | TrafficIndexWeekAgo | TravelTimeHistoricPer10KmsMins | TravelTimeLivePer10KmsMins | |
|---|---|---|---|---|---|---|---|---|
| JamsCount | 1.000 | 0.994 | 0.980 | 0.612 | 0.800 | 0.755 | 0.518 | 0.591 |
| JamsDelay | 0.994 | 1.000 | 0.978 | 0.623 | 0.805 | 0.756 | 0.518 | 0.594 |
| JamsLengthInKms | 0.980 | 0.978 | 1.000 | 0.620 | 0.793 | 0.744 | 0.483 | 0.563 |
| MinsDelay | 0.612 | 0.623 | 0.620 | 1.000 | 0.730 | 0.626 | 0.500 | 0.635 |
| TrafficIndexLive | 0.800 | 0.805 | 0.793 | 0.730 | 1.000 | 0.938 | 0.631 | 0.714 |
| TrafficIndexWeekAgo | 0.755 | 0.756 | 0.744 | 0.626 | 0.938 | 1.000 | 0.604 | 0.666 |
| TravelTimeHistoricPer10KmsMins | 0.518 | 0.518 | 0.483 | 0.500 | 0.631 | 0.604 | 1.000 | 0.980 |
| TravelTimeLivePer10KmsMins | 0.591 | 0.594 | 0.563 | 0.635 | 0.714 | 0.666 | 0.980 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Country | City | UpdateTimeUTC | JamsDelay | TrafficIndexLive | JamsLengthInKms | JamsCount | TrafficIndexWeekAgo | UpdateTimeUTCWeekAgo | TravelTimeLivePer10KmsMins | TravelTimeHistoricPer10KmsMins | MinsDelay | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | ARE | abu-dhabi | 2024-11-17 11:01:00.000 | 27.5 | 8.0 | 4.6 | 9.0 | 8.0 | 2024-11-10 11:01:00.000 | 9.440078 | 9.550711 | -0.110634 |
| 1 | ARE | abu-dhabi | 2024-11-17 10:01:00.000 | 67.2 | 9.0 | 8.3 | 21.0 | 9.0 | 2024-11-10 10:01:00.001 | 9.670244 | 9.704906 | -0.034662 |
| 2 | ARE | abu-dhabi | 2024-11-17 09:01:00.000 | 31.8 | 9.0 | 3.4 | 12.0 | 9.0 | 2024-11-10 09:01:00.001 | 9.637225 | 9.736813 | -0.099587 |
| 3 | ARE | abu-dhabi | 2024-11-17 08:01:30.001 | 89.3 | 10.0 | 10.2 | 30.0 | 10.0 | 2024-11-10 08:01:30.000 | 9.727177 | 9.738622 | -0.011445 |
| 4 | ARE | abu-dhabi | 2024-11-17 07:46:30.001 | 70.7 | 10.0 | 10.7 | 22.0 | 10.0 | 2024-11-10 07:46:30.000 | 9.718003 | 9.750348 | -0.032346 |
| 5 | ARE | abu-dhabi | 2024-11-17 07:01:30.000 | 36.7 | 9.0 | 5.7 | 13.0 | 10.0 | 2024-11-10 07:46:30.000 | 9.554564 | 9.630718 | -0.076154 |
| 6 | ARE | abu-dhabi | 2024-11-17 06:31:30.000 | 31.0 | 8.0 | 2.4 | 7.0 | 8.0 | 2024-11-10 06:31:30.000 | 9.468328 | 9.556803 | -0.088475 |
| 7 | ARE | abu-dhabi | 2024-11-17 05:01:00.000 | 20.3 | 8.0 | 6.3 | 6.0 | 8.0 | 2024-11-10 05:01:00.000 | 9.315723 | 9.271590 | 0.044133 |
| 8 | ARE | abu-dhabi | 2024-11-17 04:01:30.001 | 49.0 | 8.0 | 10.9 | 14.0 | 9.0 | 2024-11-10 04:01:30.001 | 9.072752 | 9.003036 | 0.069715 |
| 9 | ARE | abu-dhabi | 2024-11-17 03:16:30.000 | 39.5 | 8.0 | 12.0 | 11.0 | 10.0 | 2024-11-10 03:31:30.000 | 9.038538 | 9.002224 | 0.036314 |
| Country | City | UpdateTimeUTC | JamsDelay | TrafficIndexLive | JamsLengthInKms | JamsCount | TrafficIndexWeekAgo | UpdateTimeUTCWeekAgo | TravelTimeLivePer10KmsMins | TravelTimeHistoricPer10KmsMins | MinsDelay | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 457090 | ZAF | pretoria | 2024-10-01 17:01:30.000 | 87.6 | 23.0 | 8.6 | 26.0 | 13.0 | 2024-09-24 17:01:30.000 | 14.195445 | 13.403706 | 0.791740 |
| 457091 | ZAF | pretoria | 2024-10-01 16:01:30.000 | 194.1 | 40.0 | 36.6 | 54.0 | 14.0 | 2024-09-24 16:31:30.001 | 16.002154 | 14.538473 | 1.463681 |
| 457092 | ZAF | pretoria | 2024-10-01 15:01:30.000 | 528.0 | 51.0 | 118.9 | 148.0 | 13.0 | 2024-09-24 15:01:30.000 | 17.376626 | 15.715895 | 1.660731 |
| 457093 | ZAF | pretoria | 2024-10-01 14:46:30.001 | 588.4 | 49.0 | 115.5 | 150.0 | 13.0 | 2024-09-24 14:01:30.000 | 17.181881 | 15.700203 | 1.481678 |
| 457094 | ZAF | pretoria | 2024-10-01 13:46:30.000 | 168.2 | 30.0 | 29.3 | 57.0 | 13.0 | 2024-09-24 13:01:30.000 | 15.001959 | 14.376127 | 0.625833 |
| 457095 | ZAF | pretoria | 2024-10-01 12:31:30.000 | 195.1 | 27.0 | 27.2 | 66.0 | 14.0 | 2024-09-24 12:01:30.001 | 14.930880 | 14.129215 | 0.801665 |
| 457096 | ZAF | pretoria | 2024-10-01 11:31:30.000 | 78.3 | 22.0 | 9.2 | 27.0 | 15.0 | 2024-09-24 11:01:30.000 | 13.973285 | 13.630819 | 0.342466 |
| 457097 | ZAF | pretoria | 2024-10-01 10:01:30.000 | 85.0 | 21.0 | 9.7 | 29.0 | 16.0 | 2024-09-24 10:16:30.001 | 13.690491 | 13.287302 | 0.403189 |
| 457098 | ZAF | pretoria | 2024-10-01 09:01:30.000 | 68.1 | 20.0 | 6.7 | 23.0 | 15.0 | 2024-09-24 09:46:30.000 | 13.387203 | 12.983558 | 0.403646 |
| 457099 | ZAF | pretoria | 2024-10-01 08:46:30.000 | 67.7 | 20.0 | 6.6 | 22.0 | 13.0 | 2024-09-24 08:46:30.000 | 13.311492 | 12.898624 | 0.412867 |